home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
faresets.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
906b
|
24 lines
/* RCSVER $Id: faresets.sql,v 1.8 1999-11-19 14:04:20-06 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: faresets.sql
* Date: 12/28/1998
* memo: Randy Wood
* Description: Create the faresets table. This table contains definitions
* of all faresets defined to the system.
* Changes:
************************************************************************* */
CREATE TABLE faresets
(
id NUMBER(38), /* ID of this fareset */
descr VARCHAR2(20), /* Description of fareset */
route NUMBER(38), /* Route, or 0 */
run NUMBER(38), /* Run, or 0 */
fare NUMBER(38), /* Default fare for this fareset */
config_num NUMBER(38)
CONSTRAINT ref_faresets1 REFERENCES configset(num)
ON DELETE CASCADE,
CONSTRAINT pk_faresets PRIMARY KEY (id, config_num)
);